Fast Report for EDA

Dataset statistics

Number of variables	13
Number of observations	14477290
Missing cells	194
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.4 GiB
Average record size in memory	104.0 B

Variable types

Categorical	10
Numeric	3

Warnings

`remote_addr` has a high cardinality: 4405186 distinct values	High cardinality
`time_iso8601` has a high cardinality: 6014 distinct values	High cardinality
`file` has a high cardinality: 913388 distinct values	High cardinality
`uuid` has a high cardinality: 14477290 distinct values	High cardinality
`http_referer` has a high cardinality: 111821 distinct values	High cardinality
`http_user_agent` has a high cardinality: 118100 distinct values	High cardinality
`http_x_forwarded_for` has a high cardinality: 2071062 distinct values	High cardinality
`Id` has a high cardinality: 68806 distinct values	High cardinality
`request_time` is highly skewed (γ1 = 343.9438971)	Skewed
`uuid` is uniformly distributed	Uniform
`uuid` has unique values	Unique
`request_time` has 4551190 (31.4%) zeros	Zeros

Reproduction

Analysis started	2021-05-08 15:37:48.782584
Analysis finished	2021-05-08 15:52:18.251789
Duration	14 minutes and 29.47 seconds
Software version	pandas-profiling v2.12.0
Download configuration	config.yaml

remote_addr
Categorical

HIGH CARDINALITY

Distinct	4405186
Distinct (%)	30.4%
Missing	0
Missing (%)	0.0%
Memory size	110.5 MiB

f528764d624db129b32c21fbca0cb8d6	192260
15da00f033afe6b99c77e5d7d35a57e0	25577
846b1bf90397150e78844203264a7aab	25563
e2cc75b407e3f6d552f466ab5ef9bf63	25505
cb7ef43abd8148764e9941afba6c5208	25502
Other values (4405181)	14182883

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	463273280
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2215246 ?
Unique (%)	15.3%

Sample

1st row	6c455e37ea1f3f43443ecbe46bcdb4bb
2nd row	64eaa6e58e5bd71d54dd7565481a2f1d
3rd row	4d4c7b25b890132ee432bebab3940966
4th row	da177836163927897f26c718d1daf85f
5th row	affef57aacffb8aa6e911659e55f54b2

Value	Count	Frequency (%)
f528764d624db129b32c21fbca0cb8d6	192260	1.3%
15da00f033afe6b99c77e5d7d35a57e0	25577	0.2%
846b1bf90397150e78844203264a7aab	25563	0.2%
e2cc75b407e3f6d552f466ab5ef9bf63	25505	0.2%
cb7ef43abd8148764e9941afba6c5208	25502	0.2%
730eb5d625bc1f4568f107cee21cefb4	25406	0.2%
a485314653ea027199e94f05bad5ca2b	25398	0.2%
3c1289e8722f7573e9918cc6fcd2964f	25392	0.2%
081bb5cc3e5f62aa405141f36040adf9	25390	0.2%
e9ab75254c76d5c0fd13aef1004a42e0	25369	0.2%
Other values (4405176)	14055928	97.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
f528764d624db129b32c21fbca0cb8d6	192260	1.3%
15da00f033afe6b99c77e5d7d35a57e0	25577	0.2%
846b1bf90397150e78844203264a7aab	25563	0.2%
e2cc75b407e3f6d552f466ab5ef9bf63	25505	0.2%
cb7ef43abd8148764e9941afba6c5208	25502	0.2%
730eb5d625bc1f4568f107cee21cefb4	25406	0.2%
a485314653ea027199e94f05bad5ca2b	25398	0.2%
3c1289e8722f7573e9918cc6fcd2964f	25392	0.2%
081bb5cc3e5f62aa405141f36040adf9	25390	0.2%
e9ab75254c76d5c0fd13aef1004a42e0	25369	0.2%
Other values (4405176)	14055928	97.1%

Most occurring characters

Value	Count	Frequency (%)
5	29719796	6.4%
f	29298988	6.3%
b	29266953	6.3%
1	29214234	6.3%
8	29135456	6.3%
6	29132629	6.3%
2	29049423	6.3%
0	29040790	6.3%
4	28947990	6.2%
d	28903673	6.2%
Other values (6)	171563348	37.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	289775842	62.5%
Lowercase Letter	173497438	37.5%

Most frequent character per category

Value	Count	Frequency (%)
5	29719796	10.3%
1	29214234	10.1%
8	29135456	10.1%
6	29132629	10.1%
2	29049423	10.0%
0	29040790	10.0%
4	28947990	10.0%
9	28821058	9.9%
7	28380371	9.8%
3	28334095	9.8%

Value	Count	Frequency (%)
f	29298988	16.9%
b	29266953	16.9%
d	28903673	16.7%
c	28723418	16.6%
e	28660480	16.5%
a	28643926	16.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	289775842	62.5%
Latin	173497438	37.5%

Most frequent character per script

Value	Count	Frequency (%)
5	29719796	10.3%
1	29214234	10.1%
8	29135456	10.1%
6	29132629	10.1%
2	29049423	10.0%
0	29040790	10.0%
4	28947990	10.0%
9	28821058	9.9%
7	28380371	9.8%
3	28334095	9.8%

Value	Count	Frequency (%)
f	29298988	16.9%
b	29266953	16.9%
d	28903673	16.7%
c	28723418	16.6%
e	28660480	16.5%
a	28643926	16.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	463273280	100.0%

Most frequent character per block

Value	Count	Frequency (%)
5	29719796	6.4%
f	29298988	6.3%
b	29266953	6.3%
1	29214234	6.3%
8	29135456	6.3%
6	29132629	6.3%
2	29049423	6.3%
0	29040790	6.3%
4	28947990	6.2%
d	28903673	6.2%
Other values (6)	171563348	37.0%

time_iso8601
Categorical

HIGH CARDINALITY

Distinct	6014
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	110.5 MiB

2021-04-09T21:20:34+08:00	3252
2021-04-09T21:20:43+08:00	3248
2021-04-09T21:23:13+08:00	3248
2021-04-09T21:21:15+08:00	3239
2021-04-09T21:21:53+08:00	3238
Other values (6009)	14461065

Length

Max length	25
Median length	25
Mean length	25
Min length	25

Characters and Unicode

Total characters	361932250
Distinct characters	14
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	2021-03-22T12:20:00+08:00
2nd row	2021-03-22T12:20:00+08:00
3rd row	2021-03-22T12:20:00+08:00
4th row	2021-03-22T12:20:00+08:00
5th row	2021-03-22T12:20:00+08:00

Value	Count	Frequency (%)
2021-04-09T21:20:34+08:00	3252	< 0.1%
2021-04-09T21:20:43+08:00	3248	< 0.1%
2021-04-09T21:23:13+08:00	3248	< 0.1%
2021-04-09T21:21:15+08:00	3239	< 0.1%
2021-04-09T21:21:53+08:00	3238	< 0.1%
2021-04-10T21:23:44+08:00	3235	< 0.1%
2021-04-09T21:25:14+08:00	3234	< 0.1%
2021-04-10T21:21:11+08:00	3228	< 0.1%
2021-04-10T21:27:35+08:00	3224	< 0.1%
2021-04-09T21:21:11+08:00	3212	< 0.1%
Other values (6004)	14444932	99.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-04-09t21:20:34+08:00	3252	< 0.1%
2021-04-09t21:20:43+08:00	3248	< 0.1%
2021-04-09t21:23:13+08:00	3248	< 0.1%
2021-04-09t21:21:15+08:00	3239	< 0.1%
2021-04-09t21:21:53+08:00	3238	< 0.1%
2021-04-10t21:23:44+08:00	3235	< 0.1%
2021-04-09t21:25:14+08:00	3234	< 0.1%
2021-04-10t21:21:11+08:00	3228	< 0.1%
2021-04-10t21:27:35+08:00	3224	< 0.1%
2021-04-09t21:22:49+08:00	3212	< 0.1%
Other values (6004)	14444932	99.8%

Most occurring characters

Value	Count	Frequency (%)
0	91716826	25.3%
2	63490200	17.5%
:	43431870	12.0%
1	34228870	9.5%
-	28954580	8.0%
4	18498614	5.1%
8	17366875	4.8%
T	14477290	4.0%
+	14477290	4.0%
3	11026962	3.0%
Other values (4)	24262873	6.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	260591220	72.0%
Other Punctuation	43431870	12.0%
Dash Punctuation	28954580	8.0%
Uppercase Letter	14477290	4.0%
Math Symbol	14477290	4.0%

Most frequent character per category

Value	Count	Frequency (%)
0	91716826	35.2%
2	63490200	24.4%
1	34228870	13.1%
4	18498614	7.1%
8	17366875	6.7%
3	11026962	4.2%
9	8851196	3.4%
5	7046531	2.7%
7	4635876	1.8%
6	3729270	1.4%

Value	Count	Frequency (%)
-	28954580	100.0%

Value	Count	Frequency (%)
T	14477290	100.0%

Value	Count	Frequency (%)
:	43431870	100.0%

Value	Count	Frequency (%)
+	14477290	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	347454960	96.0%
Latin	14477290	4.0%

Most frequent character per script

Value	Count	Frequency (%)
0	91716826	26.4%
2	63490200	18.3%
:	43431870	12.5%
1	34228870	9.9%
-	28954580	8.3%
4	18498614	5.3%
8	17366875	5.0%
+	14477290	4.2%
3	11026962	3.2%
9	8851196	2.5%
Other values (3)	15411677	4.4%

Value	Count	Frequency (%)
T	14477290	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	361932250	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	91716826	25.3%
2	63490200	17.5%
:	43431870	12.0%
1	34228870	9.5%
-	28954580	8.0%
4	18498614	5.1%
8	17366875	4.8%
T	14477290	4.0%
+	14477290	4.0%
3	11026962	3.0%
Other values (4)	24262873	6.7%

status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	110.5 MiB

200	14477289
302	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	43431870
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	200
2nd row	200
3rd row	200
4th row	200
5th row	200

Value	Count	Frequency (%)
200	14477289	> 99.9%
302	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
200	14477289	> 99.9%
302	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	28954579	66.7%
2	14477290	33.3%
3	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	43431870	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	28954579	66.7%
2	14477290	33.3%
3	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	43431870	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	28954579	66.7%
2	14477290	33.3%
3	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43431870	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	28954579	66.7%
2	14477290	33.3%
3	1	< 0.1%

file
Categorical

HIGH CARDINALITY

Distinct	913388
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Memory size	110.5 MiB

/c1/2021/04/03_0/579989A52E63F61D92FE952F06717D89_20210403_1_1_582_mp4/084DBE6E316D033604F2363F78A3D821.m3u8	34560
/c1/2021/04/09_0/19076CF464FF1F138541D61832CACF27_20210409_1_1_1785_mp4/EBBBB4C4E9A9B37F510FEB87C2D1DFCB.m3u8	33996
/c1/2021/04/07_0/935DEFAB054FD50FDFE68A91CD6A7FA5_20210407_1_1_569_mp4/066EC1856110FFECFE939D599DF66E6B.m3u8	33122
/c1/2021/03/19_0/F3AC801ADCC688DF7036574E2415C6CA_20210319_1_1_624_mp4/0AD767483F2F54D104CE8C4F24083A2E.m3u8	32774
/c1/2021/04/09_0/022AABE72B34034DD6507A8D11C9EC97_20210409_2_1_1792_mp4/B106FBFC3E35D4ADD711D0E6615A40C8.m3u8	32518
Other values (913383)	14310320

Length

Max length	151
Median length	116
Mean length	113.8112637
Min length	73

Characters and Unicode

Total characters	1647678670
Distinct characters	47
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	381855 ?
Unique (%)	2.6%

Sample

1st row	/c1/2021/02/20_0/481B858722405F7E39837605A91E8204_20210221_2_1_1156_mp4/6561DD1FC4E37E3D6A6B9643F36E2E30.m3u8
2nd row	/c1/2021/03/20_0/F585736A7DD210F89DE3AEA196944728_20210321_2_1_1111_mp4/A4E09169781571E626E30EF155933EAE.m3u8
3rd row	/c1/2020/06/09_1/B635E0C143F43265B4522F4F5C665A06_20200609_2_1_326_mp4/AF7209FFA8EEB51BB35FB6331CEFBEF1.m3u8
4th row	/c1/2017/05/23_0/9682886A50AEC846687B165FA70C3748_20170523_1_1_585_mp4/528824180AF68D78A10545E9A395747E.m3u8
5th row	/c1/internettv/2020/09/11_0/1B19375BF694C900E2EEE947169124FE_20200911_1_1_514_ts/419B68EEDBF0CE8CFC5428407E548206.m3u8

Value	Count	Frequency (%)
/c1/2021/04/03_0/579989A52E63F61D92FE952F06717D89_20210403_1_1_582_mp4/084DBE6E316D033604F2363F78A3D821.m3u8	34560	0.2%
/c1/2021/04/09_0/19076CF464FF1F138541D61832CACF27_20210409_1_1_1785_mp4/EBBBB4C4E9A9B37F510FEB87C2D1DFCB.m3u8	33996	0.2%
/c1/2021/04/07_0/935DEFAB054FD50FDFE68A91CD6A7FA5_20210407_1_1_569_mp4/066EC1856110FFECFE939D599DF66E6B.m3u8	33122	0.2%
/c1/2021/03/19_0/F3AC801ADCC688DF7036574E2415C6CA_20210319_1_1_624_mp4/0AD767483F2F54D104CE8C4F24083A2E.m3u8	32774	0.2%
/c1/2021/04/09_0/022AABE72B34034DD6507A8D11C9EC97_20210409_2_1_1792_mp4/B106FBFC3E35D4ADD711D0E6615A40C8.m3u8	32518	0.2%
/c1/2021/04/09_0/3FD154763F0D65F4A33BFF30DCE640EB_20210409_2_1_657_mp4/B6AB695ADE44573E8CB56D4E7EBB49FE.m3u8	31647	0.2%
/c1/2021/03/26_0/7D766FA750D55E0671A058E281F47195_20210326_1_1_563_mp4/93BA6C18FFF3AAC34CE878814610D22A.m3u8	31315	0.2%
/c1/2021/04/03_0/53212C94F149E365BCC3AA62D7117241_20210403_1_1_215_mp4/164312FB15F9EEAC07CC2AA5FC2B0642.m3u8	30606	0.2%
/c1/2021/04/09_0/D402FCB9F83AA197AB792978554ED2B3_20210409_1_1_652_mp4/8DF5DD6D5490313BA318858C0539F42E.m3u8	29806	0.2%
/c1/2021/03/26_0/196731DD4A07C8752A7F53D902907A4C_20210326_1_1_207_mp4/D1D81FE2E665E246CDCC5A973CD80A05.m3u8	28184	0.2%
Other values (913378)	14158762	97.8%

Histogram of lengths of the category

Value	Count	Frequency (%)
c1/2021/04/03_0/579989a52e63f61d92fe952f06717d89_20210403_1_1_582_mp4/084dbe6e316d033604f2363f78a3d821.m3u8	34560	0.2%
c1/2021/04/09_0/19076cf464ff1f138541d61832cacf27_20210409_1_1_1785_mp4/ebbbb4c4e9a9b37f510feb87c2d1dfcb.m3u8	33996	0.2%
c1/2021/04/07_0/935defab054fd50fdfe68a91cd6a7fa5_20210407_1_1_569_mp4/066ec1856110ffecfe939d599df66e6b.m3u8	33122	0.2%
c1/2021/03/19_0/f3ac801adcc688df7036574e2415c6ca_20210319_1_1_624_mp4/0ad767483f2f54d104ce8c4f24083a2e.m3u8	32774	0.2%
c1/2021/04/09_0/022aabe72b34034dd6507a8d11c9ec97_20210409_2_1_1792_mp4/b106fbfc3e35d4add711d0e6615a40c8.m3u8	32518	0.2%
c1/2021/04/09_0/3fd154763f0d65f4a33bff30dce640eb_20210409_2_1_657_mp4/b6ab695ade44573e8cb56d4e7ebb49fe.m3u8	31647	0.2%
c1/2021/03/26_0/7d766fa750d55e0671a058e281f47195_20210326_1_1_563_mp4/93ba6c18fff3aac34ce878814610d22a.m3u8	31315	0.2%
c1/2021/04/03_0/53212c94f149e365bcc3aa62d7117241_20210403_1_1_215_mp4/164312fb15f9eeac07cc2aa5fc2b0642.m3u8	30606	0.2%
c1/2021/04/09_0/d402fcb9f83aa197ab792978554ed2b3_20210409_1_1_652_mp4/8df5dd6d5490313ba318858c0539f42e.m3u8	29806	0.2%
c1/2021/03/26_0/196731dd4a07c8752a7f53d902907a4c_20210326_1_1_207_mp4/d1d81fe2e665e246cdcc5a973cd80a05.m3u8	28184	0.2%
Other values (913378)	14158762	97.8%

Most occurring characters

Value	Count	Frequency (%)
0	151165477	9.2%
1	148104386	9.0%
2	134375689	8.2%
/	94358958	5.7%
3	90883555	5.5%
_	88022198	5.3%
8	82949822	5.0%
4	77899295	4.7%
9	70945647	4.3%
6	69007962	4.2%
Other values (37)	639965681	38.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	958077097	58.1%
Uppercase Letter	346898258	21.1%
Lowercase Letter	145835429	8.9%
Other Punctuation	108845687	6.6%
Connector Punctuation	88022198	5.3%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
t	27656118	19.0%
m	23060543	15.8%
u	14738018	10.1%
c	14729449	10.1%
n	14509861	9.9%
e	14490796	9.9%
p	8572038	5.9%
i	7253295	5.0%
v	7251101	5.0%
r	7246390	5.0%
Other values (16)	6327820	4.3%

Value	Count	Frequency (%)
0	151165477	15.8%
1	148104386	15.5%
2	134375689	14.0%
3	90883555	9.5%
8	82949822	8.7%
4	77899295	8.1%
9	70945647	7.4%
6	69007962	7.2%
7	66538952	6.9%
5	66206312	6.9%

Value	Count	Frequency (%)
E	58050811	16.7%
A	58012802	16.7%
D	57989381	16.7%
F	57960866	16.7%
C	57675376	16.6%
B	57209022	16.5%

Value	Count	Frequency (%)
/	94358958	86.7%
.	14484369	13.3%
:	2360	< 0.1%

Value	Count	Frequency (%)
_	88022198	100.0%

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1154944983	70.1%
Latin	492733687	29.9%

Most frequent character per script

Value	Count	Frequency (%)
E	58050811	11.8%
A	58012802	11.8%
D	57989381	11.8%
F	57960866	11.8%
C	57675376	11.7%
B	57209022	11.6%
t	27656118	5.6%
m	23060543	4.7%
u	14738018	3.0%
c	14729449	3.0%
Other values (22)	65651301	13.3%

Value	Count	Frequency (%)
0	151165477	13.1%
1	148104386	12.8%
2	134375689	11.6%
/	94358958	8.2%
3	90883555	7.9%
_	88022198	7.6%
8	82949822	7.2%
4	77899295	6.7%
9	70945647	6.1%
6	69007962	6.0%
Other values (5)	147231994	12.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1647678670	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	151165477	9.2%
1	148104386	9.0%
2	134375689	8.2%
/	94358958	5.7%
3	90883555	5.5%
_	88022198	5.3%
8	82949822	5.0%
4	77899295	4.7%
9	70945647	4.3%
6	69007962	4.2%
Other values (37)	639965681	38.8%

body_bytes_sent
Real number (ℝ_≥0)

Distinct	201
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	899.990504

Minimum	800
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	110.5 MiB

Quantile statistics

Minimum	800
5-th percentile	810
Q1	850
median	900
Q3	950
95-th percentile	990
Maximum	1000
Range	200
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	58.01959347
Coefficient of variation (CV)	0.06446689517
Kurtosis	-1.199709334
Mean	899.990504
Median Absolute Deviation (MAD)	50
Skewness	5.927451318 × 10^-5
Sum	1.302942352 × 10¹⁰
Variance	3366.273227
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
970	72719	0.5%
986	72700	0.5%
844	72614	0.5%
953	72594	0.5%
807	72559	0.5%
886	72553	0.5%
904	72542	0.5%
869	72540	0.5%
834	72528	0.5%
908	72503	0.5%
Other values (191)	13751438	95.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
800	72264	0.5%
801	72410	0.5%
802	71986	0.5%
803	72419	0.5%
804	72324	0.5%

Value	Count	Frequency (%)
1000	71921	0.5%
999	71893	0.5%
998	72052	0.5%
997	71944	0.5%
996	71670	0.5%

request_time
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	1302
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.001791007088

Minimum	0
Maximum	24.73
Zeros	4551190
Zeros (%)	31.4%
Negative	0
Negative (%)	0.0%
Memory size	110.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.001
Q3	0.001
95-th percentile	0.004
Maximum	24.73
Range	24.73
Interquartile range (IQR)	0.001

Descriptive statistics

Standard deviation	0.03192924597
Coefficient of variation (CV)	17.82753747
Kurtosis	178201.0368
Mean	0.001791007088
Median Absolute Deviation (MAD)	0
Skewness	343.9438971
Sum	25928.929
Variance	0.001019476748
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.001	7482735	51.7%
0	4551190	31.4%
0.002	1003824	6.9%
0.003	451721	3.1%
0.004	306058	2.1%
0.005	168414	1.2%
0.006	126058	0.9%
0.007	95521	0.7%
0.008	89801	0.6%
0.009	64977	0.4%
Other values (1292)	136991	0.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4551190	31.4%
0.001	7482735	51.7%
0.002	1003824	6.9%
0.003	451721	3.1%
0.004	306058	2.1%

Value	Count	Frequency (%)
24.73	1	< 0.1%
22.662	1	< 0.1%
22.431	1	< 0.1%
22.212	1	< 0.1%
21.498	1	< 0.1%

uuid
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	14477290
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	110.5 MiB

29215db22a324aeb99b0f6a211182e12	1
2cded688385e475788d01659456b9dcc	1
602589bdafb244e783f148d049471494	1
63ccc4b5a7e54fa18e3ce110fe739f01	1
a76189cab42040ba9d7c210972d45576	1
Other values (14477285)	14477285

Length

Max length	32
Median length	32
Mean length	32
Min length	32

Characters and Unicode

Total characters	463273280
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14477290 ?
Unique (%)	100.0%

Sample

1st row	cc8af1795c1f41d5928a812894582677
2nd row	e08080787bfb45dcbb06b2a2794bbd19
3rd row	16ef9189edb047da9eb2c80f7c699989
4th row	2ae94ad529634ba092012ee451854ba4
5th row	7e1e28044456459fab1d3aa865670398

Value	Count	Frequency (%)
29215db22a324aeb99b0f6a211182e12	1	< 0.1%
2cded688385e475788d01659456b9dcc	1	< 0.1%
602589bdafb244e783f148d049471494	1	< 0.1%
63ccc4b5a7e54fa18e3ce110fe739f01	1	< 0.1%
a76189cab42040ba9d7c210972d45576	1	< 0.1%
49ca7433f6a340d4ae530194b023ebe3	1	< 0.1%
88509ef2b45740ddae15316048773c51	1	< 0.1%
1a5e325917ce4e9abc5f234572c0d74b	1	< 0.1%
8717447e1c2f422e9ff889feb6eee1bf	1	< 0.1%
1c6698171afa4b27ae30a10ad312e368	1	< 0.1%
Other values (14477280)	14477280	> 99.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
29215db22a324aeb99b0f6a211182e12	1	< 0.1%
2cded688385e475788d01659456b9dcc	1	< 0.1%
602589bdafb244e783f148d049471494	1	< 0.1%
63ccc4b5a7e54fa18e3ce110fe739f01	1	< 0.1%
a76189cab42040ba9d7c210972d45576	1	< 0.1%
49ca7433f6a340d4ae530194b023ebe3	1	< 0.1%
88509ef2b45740ddae15316048773c51	1	< 0.1%
1a5e325917ce4e9abc5f234572c0d74b	1	< 0.1%
8717447e1c2f422e9ff889feb6eee1bf	1	< 0.1%
1c6698171afa4b27ae30a10ad312e368	1	< 0.1%
Other values (14477280)	14477280	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
4	41617507	9.0%
b	30780809	6.6%
a	30768376	6.6%
8	30757980	6.6%
9	30757268	6.6%
3	27151276	5.9%
2	27150266	5.9%
c	27149337	5.9%
6	27148653	5.9%
0	27147850	5.9%
Other values (6)	162843958	35.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	293145823	63.3%
Lowercase Letter	170127457	36.7%

Most frequent character per category

Value	Count	Frequency (%)
4	41617507	14.2%
8	30757980	10.5%
9	30757268	10.5%
3	27151276	9.3%
2	27150266	9.3%
6	27148653	9.3%
0	27147850	9.3%
5	27142384	9.3%
1	27138524	9.3%
7	27134115	9.3%

Value	Count	Frequency (%)
b	30780809	18.1%
a	30768376	18.1%
c	27149337	16.0%
d	27146720	16.0%
f	27143187	16.0%
e	27139028	16.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	293145823	63.3%
Latin	170127457	36.7%

Most frequent character per script

Value	Count	Frequency (%)
4	41617507	14.2%
8	30757980	10.5%
9	30757268	10.5%
3	27151276	9.3%
2	27150266	9.3%
6	27148653	9.3%
0	27147850	9.3%
5	27142384	9.3%
1	27138524	9.3%
7	27134115	9.3%

Value	Count	Frequency (%)
b	30780809	18.1%
a	30768376	18.1%
c	27149337	16.0%
d	27146720	16.0%
f	27143187	16.0%
e	27139028	16.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	463273280	100.0%

Most frequent character per block

Value	Count	Frequency (%)
4	41617507	9.0%
b	30780809	6.6%
a	30768376	6.6%
8	30757980	6.6%
9	30757268	6.6%
3	27151276	5.9%
2	27150266	5.9%
c	27149337	5.9%
6	27148653	5.9%
0	27147850	5.9%
Other values (6)	162843958	35.2%

http_referer
Categorical

HIGH CARDINALITY

Distinct	111821
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	110.5 MiB

-	13432309
https://www.mgtv.com/	129825
https://w.mgtv.com/	11201
https://www.mgtv.com/b/335113/11335927.html?cxid=94gw9uoaq	5250
https://www.mgtv.com/b/349986/11579395.html	4517
Other values (111816)	894188

Length

Max length	637
Median length	1
Mean length	4.304199405
Min length	1

Characters and Unicode

Total characters	62313143
Distinct characters	73
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	53939 ?
Unique (%)	0.4%

Sample

1st row	-
2nd row	-
3rd row	-
4th row	https://www.mgtv.com/b/166040/3557859.html
5th row	-

Value	Count	Frequency (%)
-	13432309	92.8%
https://www.mgtv.com/	129825	0.9%
https://w.mgtv.com/	11201	0.1%
https://www.mgtv.com/b/335113/11335927.html?cxid=94gw9uoaq	5250	< 0.1%
https://www.mgtv.com/b/349986/11579395.html	4517	< 0.1%
https://www.mgtv.com/b/349986/11404545.html	4338	< 0.1%
https://www.mgtv.com/b/361838/11387905.html?fpa=se&lastp=so_result	2585	< 0.1%
https://www.mgtv.com/b/364015/11388708.html	2479	< 0.1%
https://www.mgtv.com/b/341204/11442179.html	2204	< 0.1%
https://www.mgtv.com/b/344620/11494133.html?cxid=90f0zbamf	2193	< 0.1%
Other values (111811)	880389	6.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
	13432309	92.8%
https://www.mgtv.com	129996	0.9%
https://w.mgtv.com	11201	0.1%
https://www.mgtv.com/b/335113/11335927.html?cxid=94gw9uoaq	5250	< 0.1%
https://www.mgtv.com/b/349986/11579395.html	4517	< 0.1%
https://www.mgtv.com/b/349986/11404545.html	4338	< 0.1%
https://www.mgtv.com/b/361838/11387905.html?fpa=se&lastp=so_result	2585	< 0.1%
https://www.mgtv.com/b/364015/11388708.html	2479	< 0.1%
https://www.mgtv.com/b/341204/11442179.html	2204	< 0.1%
https://www.mgtv.com/b/344620/11494133.html?cxid=90f0zbamf	2193	< 0.1%
Other values (111399)	880218	6.1%

Most occurring characters

Value	Count	Frequency (%)
-	13450932	21.6%
/	4825245	7.7%
t	4271377	6.9%
m	3179968	5.1%
w	3104529	5.0%
.	2995385	4.8%
1	2049596	3.3%
h	2027148	3.3%
3	1972966	3.2%
4	1494966	2.4%
Other values (63)	22941031	36.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	24555414	39.4%
Decimal Number	13701265	22.0%
Dash Punctuation	13450932	21.6%
Other Punctuation	9699984	15.6%
Math Symbol	485062	0.8%
Uppercase Letter	330705	0.5%
Connector Punctuation	89781	0.1%

Most frequent character per category

Value	Count	Frequency (%)
t	4271377	17.4%
m	3179968	13.0%
w	3104529	12.6%
h	2027148	8.3%
c	1388513	5.7%
p	1310128	5.3%
s	1303110	5.3%
o	1225565	5.0%
g	1095633	4.5%
l	1085588	4.4%
Other values (16)	4563855	18.6%

Value	Count	Frequency (%)
F	105907	32.0%
A	74225	22.4%
E	62188	18.8%
D	33231	10.0%
B	24009	7.3%
C	14474	4.4%
P	5842	1.8%
S	3528	1.1%
I	723	0.2%
K	516	0.2%
Other values (16)	6062	1.8%

Value	Count	Frequency (%)
1	2049596	15.0%
3	1972966	14.4%
4	1494966	10.9%
0	1489462	10.9%
5	1248232	9.1%
9	1228925	9.0%
2	1192620	8.7%
6	1069630	7.8%
8	1029338	7.5%
7	925530	6.8%

Value	Count	Frequency (%)
/	4825245	49.7%
.	2995385	30.9%
:	1029656	10.6%
%	347324	3.6%
?	311592	3.2%
&	190778	2.0%
,	4	< 0.1%

Value	Count	Frequency (%)
=	484808	99.9%
~	254	0.1%

Value	Count	Frequency (%)
-	13450932	100.0%

Value	Count	Frequency (%)
_	89781	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	37427024	60.1%
Latin	24886119	39.9%

Most frequent character per script

Value	Count	Frequency (%)
t	4271377	17.2%
m	3179968	12.8%
w	3104529	12.5%
h	2027148	8.1%
c	1388513	5.6%
p	1310128	5.3%
s	1303110	5.2%
o	1225565	4.9%
g	1095633	4.4%
l	1085588	4.4%
Other values (42)	4894560	19.7%

Value	Count	Frequency (%)
-	13450932	35.9%
/	4825245	12.9%
.	2995385	8.0%
1	2049596	5.5%
3	1972966	5.3%
4	1494966	4.0%
0	1489462	4.0%
5	1248232	3.3%
9	1228925	3.3%
2	1192620	3.2%
Other values (11)	5478695	14.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	62313143	100.0%

Most frequent character per block

Value	Count	Frequency (%)
-	13450932	21.6%
/	4825245	7.7%
t	4271377	6.9%
m	3179968	5.1%
w	3104529	5.0%
.	2995385	4.8%
1	2049596	3.3%
h	2027148	3.3%
3	1972966	3.2%
4	1494966	2.4%
Other values (63)	22941031	36.8%

http_user_agent
Categorical

HIGH CARDINALITY

Distinct	118100
Distinct (%)	0.8%
Missing	194
Missing (%)	< 0.1%
Memory size	110.5 MiB

Go-http-client/1.1	7329791
MGTV-iPhone-appstore/6.8.4.2103171510 CFNetwork/1220.1 Darwin/20.3.0	206535
MGTV-iPhone-appstore/6.8.6.2103301510 CFNetwork/1220.1 Darwin/20.3.0	164734
Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36	130771
MGTV-iPhone-appstore/6.8.4.2103171510 CFNetwork/1128.0.1 Darwin/19.6.0	105254
Other values (118095)	6540011

Length

Max length	924
Median length	18
Mean length	51.18498938
Min length	1

Characters and Unicode

Total characters	741010005
Distinct characters	93
Distinct categories	12 ?
Distinct scripts	3 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	63658 ?
Unique (%)	0.4%

Sample

1st row	ImgoTV-ipad-AppStore/6.3.8.20123119 CFNetwork/1128.0.1 Darwin/19.6.0
2nd row	Dalvik/2.1.0 (Linux; U; Android 9; ART-AL00x Build/HUAWEIART-AL00x) imgotv-aphone-6.8.5
3rd row	Dalvik/2.1.0 (Linux; U; Android 10; PCNM00 Build/QKQ1.190915.002) imgotv-aphone-6.7.4
4th row	Mozilla/5.0 (iPad; CPU OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 VideoArticle/9.4.9 JsSdk/2.0 NetType/WIFI (Video 5.4.9 12.4.8) newiPad
5th row	Go-http-client/1.1

Value	Count	Frequency (%)
Go-http-client/1.1	7329791	50.6%
MGTV-iPhone-appstore/6.8.4.2103171510 CFNetwork/1220.1 Darwin/20.3.0	206535	1.4%
MGTV-iPhone-appstore/6.8.6.2103301510 CFNetwork/1220.1 Darwin/20.3.0	164734	1.1%
Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36	130771	0.9%
MGTV-iPhone-appstore/6.8.4.2103171510 CFNetwork/1128.0.1 Darwin/19.6.0	105254	0.7%
ImgoTV-ipad-AppStore/6.3.10.21031716 CFNetwork/1220.1 Darwin/20.3.0	92837	0.6%
MGTV-iPhone-appstore/6.8.6.2103301510 CFNetwork/1128.0.1 Darwin/19.6.0	82329	0.6%
Dalvik/2.1.0 (Linux; U; Android 9.0.0; MI 10 MIUI/11.11.22) imgotv-aphone-6.6.4	76350	0.5%
MGTV-iPhone-appstore/6.8.3.2103112210 CFNetwork/1220.1 Darwin/20.3.0	72172	0.5%
Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36	71090	0.5%
Other values (118090)	6145233	42.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
go-http-client/1.1	7329791	12.3%
linux	4141260	7.0%
android	4140140	7.0%
u	4140020	7.0%
dalvik/2.1.0	4127931	6.9%
10	2730332	4.6%
imgotv-aphone-6.8.6	1879812	3.2%
imgotv-aphone-6.8.5	1384776	2.3%
mozilla/5.0	1031857	1.7%
like	1008465	1.7%
Other values (60429)	27512443	46.3%

Most occurring characters

Value	Count	Frequency (%)
.	49588225	6.7%
1	45510336	6.1%
	44979176	6.1%
i	37442493	5.1%
0	35864450	4.8%
t	31425502	4.2%
-	30769848	4.2%
o	30392022	4.1%
/	25897024	3.5%
n	24457402	3.3%
Other values (83)	384683527	51.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	299310758	40.4%
Decimal Number	151921203	20.5%
Uppercase Letter	111006540	15.0%
Other Punctuation	90464014	12.2%
Space Separator	44979176	6.1%
Dash Punctuation	30769848	4.2%
Open Punctuation	6163379	0.8%
Close Punctuation	6163374	0.8%
Connector Punctuation	220579	< 0.1%
Math Symbol	10426	< 0.1%
Other values (2)	708	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
A	14130935	12.7%
G	10205727	9.2%
L	8895839	8.0%
D	6737384	6.1%
U	6427456	5.8%
M	6331020	5.7%
N	5474776	4.9%
W	5349833	4.8%
T	4688047	4.2%
B	4446872	4.0%
Other values (16)	38318651	34.5%

Value	Count	Frequency (%)
i	37442493	12.5%
t	31425502	10.5%
o	30392022	10.2%
n	24457402	8.2%
e	22465539	7.5%
l	19563369	6.5%
p	18051474	6.0%
a	15719356	5.3%
h	13851430	4.6%
d	13829168	4.6%
Other values (16)	72113003	24.1%

Value	Count	Frequency (%)
.	49588225	54.8%
/	25897024	28.6%
;	13544653	15.0%
,	976647	1.1%
%	397897	0.4%
:	56445	0.1%
@	1444	< 0.1%
*	705	< 0.1%
#	702	< 0.1%
&	169	< 0.1%
Other values (3)	103	< 0.1%

Value	Count	Frequency (%)
1	45510336	30.0%
0	35864450	23.6%
2	15001756	9.9%
6	14431503	9.5%
3	9411913	6.2%
8	8979007	5.9%
5	6872851	4.5%
7	6184586	4.1%
9	5542884	3.6%
4	4121917	2.7%

Value	Count	Frequency (%)
文	1	20.0%
件	1	20.0%
全	1	20.0%
能	1	20.0%
王	1	20.0%

Value	Count	Frequency (%)
+	9683	92.9%
~	696	6.7%
\|	24	0.2%
=	23	0.2%

Value	Count	Frequency (%)
(	6163373	> 99.9%
[	6	< 0.1%

Value	Count	Frequency (%)
)	6163368	> 99.9%
]	6	< 0.1%

Value	Count	Frequency (%)
^	702	99.9%
`	1	0.1%

Value	Count	Frequency (%)
-	30769848	100.0%

Value	Count	Frequency (%)
	44979176	100.0%

Value	Count	Frequency (%)
_	220579	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	410317298	55.4%
Common	330692702	44.6%
Han	5	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
i	37442493	9.1%
t	31425502	7.7%
o	30392022	7.4%
n	24457402	6.0%
e	22465539	5.5%
l	19563369	4.8%
p	18051474	4.4%
a	15719356	3.8%
A	14130935	3.4%
h	13851430	3.4%
Other values (42)	182817776	44.6%

Value	Count	Frequency (%)
.	49588225	15.0%
1	45510336	13.8%
	44979176	13.6%
0	35864450	10.8%
-	30769848	9.3%
/	25897024	7.8%
2	15001756	4.5%
6	14431503	4.4%
;	13544653	4.1%
3	9411913	2.8%
Other values (26)	45693818	13.8%

Value	Count	Frequency (%)
文	1	20.0%
件	1	20.0%
全	1	20.0%
能	1	20.0%
王	1	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	741010000	> 99.9%
CJK	5	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
.	49588225	6.7%
1	45510336	6.1%
	44979176	6.1%
i	37442493	5.1%
0	35864450	4.8%
t	31425502	4.2%
-	30769848	4.2%
o	30392022	4.1%
/	25897024	3.5%
n	24457402	3.3%
Other values (78)	384683522	51.9%

Value	Count	Frequency (%)
文	1	20.0%
件	1	20.0%
全	1	20.0%
能	1	20.0%
王	1	20.0%

http_x_forwarded_for
Categorical

HIGH CARDINALITY

Distinct	2071062
Distinct (%)	14.3%
Missing	0
Missing (%)	0.0%
Memory size	110.5 MiB

-	2018472
b815d5425eac36951c5dd43a60690df6	234073
4ce875fe568a297345bc8677a5da5abb	234053
bb34f10e2b27ced77ad5384e7ab95032	233930
527155957fd152e37702ff76f3193cfb	233859
Other values (2071057)	11522903

Length

Max length	131
Median length	32
Mean length	41.57135293
Min length	1

Characters and Unicode

Total characters	601840532
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1066072 ?
Unique (%)	7.4%

Sample

1st row	6c455e37ea1f3f43443ecbe46bcdb4bb
2nd row	-
3rd row	-
4th row	aaa477e9b59a19d1a1a6f5fc0d869bfe
5th row	bb34f10e2b27ced77ad5384e7ab95032

Value	Count	Frequency (%)
-	2018472	13.9%
b815d5425eac36951c5dd43a60690df6	234073	1.6%
4ce875fe568a297345bc8677a5da5abb	234053	1.6%
bb34f10e2b27ced77ad5384e7ab95032	233930	1.6%
527155957fd152e37702ff76f3193cfb	233859	1.6%
68cb6218c13547be5924970a6c5ce299	233549	1.6%
cf402f90900932518e83d47db7540b3b,3f0165ec0a29c8a954c806264acb8437	48387	0.3%
cf402f90900932518e83d47db7540b3b,b6955f515645ab1f4192ae0ddb78d6e2	48189	0.3%
3b774c4e91ade00ef45833c4316fd8b1,e4c41df8cd856981cef9a66a810be62b	48142	0.3%
3b774c4e91ade00ef45833c4316fd8b1,460417f487042281a5035b8d68438886	47603	0.3%
Other values (2071052)	11097033	76.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
	2018472	13.9%
b815d5425eac36951c5dd43a60690df6	234073	1.6%
4ce875fe568a297345bc8677a5da5abb	234053	1.6%
bb34f10e2b27ced77ad5384e7ab95032	233930	1.6%
527155957fd152e37702ff76f3193cfb	233859	1.6%
68cb6218c13547be5924970a6c5ce299	233549	1.6%
cf402f90900932518e83d47db7540b3b,3f0165ec0a29c8a954c806264acb8437	48387	0.3%
cf402f90900932518e83d47db7540b3b,b6955f515645ab1f4192ae0ddb78d6e2	48189	0.3%
3b774c4e91ade00ef45833c4316fd8b1,e4c41df8cd856981cef9a66a810be62b	48142	0.3%
3b774c4e91ade00ef45833c4316fd8b1,460417f487042281a5035b8d68438886	47603	0.3%
Other values (2071052)	11097033	76.7%

Most occurring characters

Value	Count	Frequency (%)
3	43624839	7.2%
6	42275205	7.0%
9	40008871	6.6%
a	38507373	6.4%
0	37578756	6.2%
4	37438131	6.2%
8	37044111	6.2%
5	36739683	6.1%
d	36735026	6.1%
1	36310628	6.0%
Other values (8)	215577909	35.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	381063390	63.3%
Lowercase Letter	212663522	35.3%
Other Punctuation	6095148	1.0%
Dash Punctuation	2018472	0.3%

Most frequent character per category

Value	Count	Frequency (%)
3	43624839	11.4%
6	42275205	11.1%
9	40008871	10.5%
0	37578756	9.9%
4	37438131	9.8%
8	37044111	9.7%
5	36739683	9.6%
1	36310628	9.5%
7	35580164	9.3%
2	34463002	9.0%

Value	Count	Frequency (%)
a	38507373	18.1%
d	36735026	17.3%
b	35332896	16.6%
e	35301330	16.6%
c	34441077	16.2%
f	32345820	15.2%

Value	Count	Frequency (%)
-	2018472	100.0%

Value	Count	Frequency (%)
,	6095148	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	389177010	64.7%
Latin	212663522	35.3%

Most frequent character per script

Value	Count	Frequency (%)
3	43624839	11.2%
6	42275205	10.9%
9	40008871	10.3%
0	37578756	9.7%
4	37438131	9.6%
8	37044111	9.5%
5	36739683	9.4%
1	36310628	9.3%
7	35580164	9.1%
2	34463002	8.9%
Other values (2)	8113620	2.1%

Value	Count	Frequency (%)
a	38507373	18.1%
d	36735026	17.3%
b	35332896	16.6%
e	35301330	16.6%
c	34441077	16.2%
f	32345820	15.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	601840532	100.0%

Most frequent character per block

Value	Count	Frequency (%)
3	43624839	7.2%
6	42275205	7.0%
9	40008871	6.6%
a	38507373	6.4%
0	37578756	6.2%
4	37438131	6.2%
8	37044111	6.2%
5	36739683	6.1%
d	36735026	6.1%
1	36310628	6.0%
Other values (8)	215577909	35.8%

pno
Real number (ℝ_≥0)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	440606.5055

Minimum	1010
Maximum	1131010
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	110.5 MiB

Quantile statistics

Minimum	1010
5-th percentile	1010
Q1	1141
median	1141
Q3	1101020
95-th percentile	1131010
Maximum	1131010
Range	1130000
Interquartile range (IQR)	1099879

Descriptive statistics

Standard deviation	540886.0453
Coefficient of variation (CV)	1.227594324
Kurtosis	-1.82412063
Mean	440606.5055
Median Absolute Deviation (MAD)	111
Skewness	0.4184902382
Sum	6.378788156 × 10¹²
Variance	2.92557714 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1141	6004441	41.5%
1101010	2027897	14.0%
1101141	1325350	9.2%
1010	1135175	7.8%
1030	1023812	7.1%
1101020	1010191	7.0%
1131010	980775	6.8%
1101021	413704	2.9%
1120	305156	2.1%
1021	225931	1.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1010	1135175	7.8%
1021	225931	1.6%
1030	1023812	7.1%
1120	305156	2.1%
1121	24858	0.2%

Value	Count	Frequency (%)
1131010	980775	6.8%
1101141	1325350	9.2%
1101021	413704	2.9%
1101020	1010191	7.0%
1101010	2027897	14.0%

Id
Categorical

HIGH CARDINALITY

Distinct	68806
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	110.5 MiB

-	14408028
1617449162208	3
1618060943325	3
1617625226068	3
1617974649600	3
Other values (68801)	69250

Length

Max length	13
Median length	1
Mean length	1.057408603
Min length	1

Characters and Unicode

Total characters	15308411
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	68352 ?
Unique (%)	0.5%

Sample

1st row	-
2nd row	-
3rd row	-
4th row	-
5th row	-

Value	Count	Frequency (%)
-	14408028	99.5%
1617449162208	3	< 0.1%
1618060943325	3	< 0.1%
1617625226068	3	< 0.1%
1617974649600	3	< 0.1%
1618060948027	2	< 0.1%
1616387031657	2	< 0.1%
1617798045461	2	< 0.1%
1617625603940	2	< 0.1%
1617974700673	2	< 0.1%
Other values (68796)	69240	0.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
	14408028	99.5%
1617974649600	3	< 0.1%
1618060943325	3	< 0.1%
1617625226068	3	< 0.1%
1617449162208	3	< 0.1%
1617625240411	2	< 0.1%
1617625344048	2	< 0.1%
1617625287271	2	< 0.1%
1617625569999	2	< 0.1%
1617276132628	2	< 0.1%
Other values (68796)	69240	0.5%

Most occurring characters

Value	Count	Frequency (%)
-	14408028	94.1%
1	188296	1.2%
6	155337	1.0%
7	108655	0.7%
9	77977	0.5%
4	71128	0.5%
8	70029	0.5%
0	60371	0.4%
2	59245	0.4%
5	57761	0.4%

Most occurring categories

Value	Count	Frequency (%)
Dash Punctuation	14408028	94.1%
Decimal Number	900383	5.9%

Most frequent character per category

Value	Count	Frequency (%)
1	188296	20.9%
6	155337	17.3%
7	108655	12.1%
9	77977	8.7%
4	71128	7.9%
8	70029	7.8%
0	60371	6.7%
2	59245	6.6%
5	57761	6.4%
3	51584	5.7%

Value	Count	Frequency (%)
-	14408028	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	15308411	100.0%

Most frequent character per script

Value	Count	Frequency (%)
-	14408028	94.1%
1	188296	1.2%
6	155337	1.0%
7	108655	0.7%
9	77977	0.5%
4	71128	0.5%
8	70029	0.5%
0	60371	0.4%
2	59245	0.4%
5	57761	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15308411	100.0%

Most frequent character per block

Value	Count	Frequency (%)
-	14408028	94.1%
1	188296	1.2%
6	155337	1.0%
7	108655	0.7%
9	77977	0.5%
4	71128	0.5%
8	70029	0.5%
0	60371	0.4%
2	59245	0.4%
5	57761	0.4%

auth_ret
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	110.5 MiB

0	11781340
1	2695950

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	14477290
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	11781340	81.4%
1	2695950	18.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	11781340	81.4%
1	2695950	18.6%

Most occurring characters

Value	Count	Frequency (%)
0	11781340	81.4%
1	2695950	18.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	14477290	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	11781340	81.4%
1	2695950	18.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	14477290	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	11781340	81.4%
1	2695950	18.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14477290	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	11781340	81.4%
1	2695950	18.6%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	remote_addr	time_iso8601	status	file	body_bytes_sent	request_time	uuid	http_referer	http_user_agent	http_x_forwarded_for	pno	Id	auth_ret
0	6c455e37ea1f3f43443ecbe46bcdb4bb	2021-03-22T12:20:00+08:00	200	/c1/2021/02/20_0/481B858722405F7E39837605A91E8204_20210221_2_1_1156_mp4/6561DD1FC4E37E3D6A6B9643F36E2E30.m3u8	916	0.003	cc8af1795c1f41d5928a812894582677	-	ImgoTV-ipad-AppStore/6.3.8.20123119 CFNetwork/1128.0.1 Darwin/19.6.0	6c455e37ea1f3f43443ecbe46bcdb4bb	1101021	-	0
1	64eaa6e58e5bd71d54dd7565481a2f1d	2021-03-22T12:20:00+08:00	200	/c1/2021/03/20_0/F585736A7DD210F89DE3AEA196944728_20210321_2_1_1111_mp4/A4E09169781571E626E30EF155933EAE.m3u8	966	0.002	e08080787bfb45dcbb06b2a2794bbd19	-	Dalvik/2.1.0 (Linux; U; Android 9; ART-AL00x Build/HUAWEIART-AL00x) imgotv-aphone-6.8.5	-	1101010	-	1
2	4d4c7b25b890132ee432bebab3940966	2021-03-22T12:20:00+08:00	200	/c1/2020/06/09_1/B635E0C143F43265B4522F4F5C665A06_20200609_2_1_326_mp4/AF7209FFA8EEB51BB35FB6331CEFBEF1.m3u8	908	0.000	16ef9189edb047da9eb2c80f7c699989	-	Dalvik/2.1.0 (Linux; U; Android 10; PCNM00 Build/QKQ1.190915.002) imgotv-aphone-6.7.4	-	1131010	-	0
3	da177836163927897f26c718d1daf85f	2021-03-22T12:20:00+08:00	200	/c1/2017/05/23_0/9682886A50AEC846687B165FA70C3748_20170523_1_1_585_mp4/528824180AF68D78A10545E9A395747E.m3u8	897	0.001	2ae94ad529634ba092012ee451854ba4	https://www.mgtv.com/b/166040/3557859.html	Mozilla/5.0 (iPad; CPU OS 12_4_8 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 VideoArticle/9.4.9 JsSdk/2.0 NetType/WIFI (Video 5.4.9 12.4.8) newiPad	aaa477e9b59a19d1a1a6f5fc0d869bfe	1121	-	0
4	affef57aacffb8aa6e911659e55f54b2	2021-03-22T12:20:00+08:00	200	/c1/internettv/2020/09/11_0/1B19375BF694C900E2EEE947169124FE_20200911_1_1_514_ts/419B68EEDBF0CE8CFC5428407E548206.m3u8	872	0.001	7e1e28044456459fab1d3aa865670398	-	Go-http-client/1.1	bb34f10e2b27ced77ad5384e7ab95032	1141	-	0
5	50f0c33ea2cc1396dabf8d6b87e29924	2021-03-22T12:20:00+08:00	200	/c1/ugc/2020/08/28_0/1EFC7CE6D5D2438003EB4831A5D16C7A_20200828_1_1_831_mp4/1EFC7CE6D5D2438003EB4831A5D16C7A.m3u8	887	0.000	574c8128f2a34c06a9b5020891644be3	-	Dalvik/2.1.0 (Linux; U; Android 9; S1W Build/PPR1.180610.011) imgotv-aphone-6.8.1	50f0c33ea2cc1396dabf8d6b87e29924	1010	-	0
6	5e65cf248d09fc5a85bdfaa91730f941	2021-03-22T12:20:00+08:00	200	/c1/2018/09/28_0/EE56CA0944B101EE772A351C93DE11C5_20180928_1_1_416_mp4/984DE33F32FA849A923BDBA14DE53A52.m3u8	944	0.001	616a1c94b0f34300829e3eaf2e6b566a	-	Dalvik/2.1.0 (Linux; U; Android 9; vivo X21A Build/PKQ1.180819.001) imgotv-aphone-6.8.5	-	1010	-	0
7	9969257ba05151554902e600f906778a	2021-03-22T12:20:00+08:00	200	/c1/2021/03/19_0/12C74013D7B1B022D98098D94C4CFD8B_20210319_1_1_2370_mp4/E8B1E6A711C14241C9C9B7C2B3863543.m3u8	968	0.000	200f4728a3c94f729f217fc976090bc8	https://www.mgtv.com/b/354045/11396546.html	Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36	af4d14e020570b7ec39b5b886835f6b7	1030	-	0
8	ba502af9b23d4866f52ea9ff345d2106	2021-03-22T12:20:00+08:00	200	/c1/2021/02/06_1/88DD62A8610401A54BB4FDB2C66D372B_20210208_2_1_1086_mp4/6402ABFEF811CA8E20E5C85A4E6B079D.m3u8	838	0.001	6ce4e6747d6f4d0aa7ab44916d69d59c	-	ImgoTV-ipad-AppStore/6.3.9.21030517 CFNetwork/1209 Darwin/20.2.0	317dd352917e837ae0c46deb80f923aa	1101021	-	0
9	9a866b922b4564c0b9a2f03e98d1e3ae	2021-03-22T12:20:00+08:00	200	/c1/2018/09/26_0/E42F9772724C3627722F408D923E264A_20180926_1_1_1440_mp4/5BD38307F55EFDFBBB55A58AD67025C7.m3u8	974	0.001	ea7fbea1647b4b818cf7dac0fe21b8cb	-	Dalvik/2.1.0 (Linux; U; Android 9; V1945A Build/PKQ1.190626.001) imgotv-aphone-6.8.4	9a866b922b4564c0b9a2f03e98d1e3ae	1010	-	0

Last rows

	remote_addr	time_iso8601	status	file	body_bytes_sent	request_time	uuid	http_referer	http_user_agent	http_x_forwarded_for	pno	Id	auth_ret
14477280	401a4dda7eb323f1434eeae2eae17d61	2021-04-10T21:29:59+08:00	200	/c1/internettv/2018/06/21_0/AD8957707DA5683B1F2E0A7545E74954_20180621_1_1_1164_ts/85D65E7883C48527EB3ED9FFC64EF8EA.m3u8	865	0.000	eeb5c9f0c96e45d4ae5373816f7a022a	-	Go-http-client/1.1	d3053ecc7317dcbcd6373d9788b931da,116074ddb263e0fc3e9f13111bebd97a	1141	-	0
14477281	4fb80f13f377fb753e581fd2fe9c6d99	2021-04-10T21:29:59+08:00	200	/c1/internettv/2020/06/04_0/E9FDF73B61A592BD0E09527593A35F47_20200604_1_1_787_ts/0880D5669FAFF5B66F75EDA464F8423F.m3u8	834	0.001	ba2c578f0d22477bb60ee2bb4e955c9f	-	Go-http-client/1.1	0a32aa93d13a16dd4628728a3fe75621,3f0165ec0a29c8a954c806264acb8437	1141	-	1
14477282	5dd72d98c765879856a2e6ebece85d1c	2021-04-10T21:29:59+08:00	200	/c1/2020/07/15_0/D51880A6B878C7DAECC6AB65B82EB0ED_20200715_1_1_351_mp4/95B160D5822221B1047232B2DDFA12D7.m3u8	971	0.001	af5647a651a24e79b10853c1e528db6f	-	MGTV-iPhone-appstore/6.1.3.1812061610 CFNetwork/711.5.6 Darwin/14.0.0	cfb602127c2672d0aa2c67a7df7aea71	1120	-	0
14477283	460f209ba797187919ab9f764b03c23f	2021-04-10T21:29:59+08:00	200	/c1/2021/02/18_0/62F8D181FBF8B763577B797ACE54F884_20210218_1_1_374_mp4/41BD712B5FA578A095A52864F46BE947.m3u8	880	0.001	9fa4c64eaf25482e9ac906a3733df645	-	Dalvik/2.1.0 (Linux; U; Android 10; PCHM10 Build/QKQ1.200209.002) imgotv-aphone-6.8.6	-	1131010	-	1
14477284	d9fdd48b48000e794261f7010476740c	2021-04-10T21:29:59+08:00	200	/c1/internettv/2021/03/25_0/930C81826B2CC2DA77693C098F2A37B8_20210330_2_1_763_mp4/3E7E7D30DA997B52D7FFEFD23C0F6D28.m3u8	838	0.009	fe09e01920774e42ac8a7cf1089f33ae	-	Go-http-client/1.1	dfbd8ae63d4045452993f636a366cb66,116074ddb263e0fc3e9f13111bebd97a	1101141	-	0
14477285	e3aa71aa8088614e03134bc9b6078504	2021-04-10T21:30:00+08:00	200	/c1/2021/04/06_0/CDDD7E69F07E11B5A381A2A75121E6D3_20210406_2_1_277_mp4/B9E223654C295F4735CF7EFB346A136E.m3u8	948	0.007	7cab750a992a4c62ac8a43ab0a785695	-	Dalvik/2.1.0 (Linux; U; Android 10; TAS-AN00 Build/HUAWEITAS-AN00) imgotv-aphone-6.8.6	-	1101010	-	0
14477286	d90a5c809b4100d326ef487c3e247037	2021-04-10T21:30:00+08:00	200	/c1/internettv/2020/07/12_0/15736F5F87C7F833FA00E2CA467754F3_20200712_1_1_955_ts/A312A6D77B78CB6DB43B26A294744828.m3u8	844	0.000	27a793b76f7046c6879ee62652dd9eb9	-	Go-http-client/1.1	d3053ecc7317dcbcd6373d9788b931da,cdfd154e4e70778fa29d32e35477402c	1141	-	0
14477287	b8f960e721df22b38b257f4a40611a25	2021-04-10T21:30:00+08:00	200	/c1/internettv/2021/04/06_0/8B25921195482080D73A871DC6ED33A6_20210406_1_1_983_ts/BD6D409CBE5BBD7F0C4142197B8DB704.m3u8	895	0.001	51ac87c8290b4fa387a352ae83e68a6b	-	Go-http-client/1.1	3b774c4e91ade00ef45833c4316fd8b1,b6955f515645ab1f4192ae0ddb78d6e2	1141	-	0
14477288	623af85c05ac5f4a4c93e4c5cd3fc917	2021-04-10T21:30:00+08:00	200	/c1/2021/03/04_1/830CCB31E60A733A6680EB009E0A6AAF_20210304_2_1_631_mp4/B02432801C9BA64AA574F9D866F93357.m3u8	944	0.002	1c101c94dcc44bd0b876a7c1edd2ac26	-	Dalvik/2.1.0 (Linux; U; Android 10; JEF-AN20 Build/HUAWEIJEF-AN20) imgotv-aphone-6.8.6	-	1131010	-	0
14477289	4870445dcac98155d9f9cf10c0e348b4	2021-04-10T21:30:00+08:00	200	/c1/2021/04/10_0/4F7A8D20648453D2028557367E7A7DC2_20210410_2_1_1167_mp4/C069C2ADC8B8EA0224E55AFF0212560C.m3u8	843	0.001	4a60d2dae8a543f2b7c9463db4e88bf3	-	Dalvik/2.1.0 (Linux; U; Android 10; WKG-AN00 Build/HUAWEIWKG-AN00) imgotv-aphone-6.8.6	-	1101010	-	0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values